Problem Note 64614: Custom sorts that include values greater than 256 characters return errors in SAS® Visual Analytics
Overview
If a data item with a custom sort includes a value that is greater than 256 characters, then you see errors when you try to use the data item, and when you open the Edit Custom Sort dialog box. The errors depend on your release of SAS Visual Analytics. There is no workaround that enables you to use a value that is greater than 256 characters in a custom sort.
Release 7.4
If you try to add the data item with the custom sort to an object, you see a red X in the lower right corner of the object and the tooltip contains this error:
The data source does not contain valid values.
If you try to edit the custom sort, the Edit Custom Sort dialog box contains an error that is similar to this:
There was an error when retrieving category values.
Release 7.5
If you try to add the data item with the custom sort to an object, you see an error that is similar to this:
An error occurred com.sas.lasr.LASRException: ERROR: The user-defined programming statements could not be parsed.
The same error appears if you try to edit the custom sort.
Release 8.2 and later
If you try to add the data item with the custom sort to an object, you see an error that is similar to this:
An error occurred. com.sas.cas.CASException: The user-defined programming
statements could not be parsed. (severity=2 reason=6 statusCode=2710055)
5 ERROR: The user-defined programming statements could not be parsed.
5 ERROR: Invalid character string constant.
5 ERROR: Failure opening table 'CUSTOMSORT'
5 ERROR: The action stopped due to errors.
debug=0x887ff837:TKCASTAB_PARSE_ERROR
The same error appears if you try to edit the custom sort.
Operating System and Release Information
SAS System | SAS Visual Analytics | Linux for x64 | 7.4 | 7.51 | 9.4 TS1M4 | 9.4 TS1M7 |
Microsoft® Windows® for x64 | 7.4 | 7.51 | 9.4 TS1M4 | 9.4 TS1M7 |
SAS System | SAS Visual Analytics (on SAS Viya) | Linux for x64 | 8.2 | 2020.1 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If your custom sort includes a value that is greater than 256 characters, then you see errors when you try to use the data item with the custom sort, and when you open the Edit Custom Sort dialog box. The errors depend on your release of SAS Visual Analytics.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2019-08-14 14:54:46 |
Date Created: | 2019-08-13 15:18:56 |